Open in design view
To open a table, form, query, report, macro, or module in Design view:
1) Choose the appropriate tab in the Database window.
NOTE: There are 6 object tabs: 'Tables', 'Forms', 'Queries', Reports', 'Macros', and 'Modules'.
2) Select the desired object from the list box in the Database window.
3) Choose the 'Design' button in the Database window. (The selected table, form, query, report, macro, or module opens in Design view.)